<html>
    <head>
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> 
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">

        <title>Facebook</title></head>
    <script src="//ajax.googleapis.com/ajax/libs/chrome-frame/1.0.3/CFInstall.min.js"></script>
    <body>   
        <?php
        require_once './model/db.php';
        ?>
        <h1>Lê Công Nguyên</h1>
        <?php
        $query = "SELECT * FROM companies";
        $companies = getFilms($query);
        $query = "SELECT * FROM apps";
        $apps = getFilms($query);
        ?>
        <form method="POST">
            Min fans<input type="text" name="min_fans" value="1"><br>
            Max fans<input type="text" name="max_fans" value="10"><br>
            Keyword <input type="text" name="keyword" value="cafe"><br>
            Company<select name="id_company">
                <option value="0">company </option>
                <?php foreach ($companies as $company): ?>
                    <option value="<?php echo $company['id'] ?>"><?php echo $company['name'] ?></option>
                <?php endforeach; ?>
            </select>
            Application<select name="id_apps">
                <option value="0">apps </option>
                <?php foreach ($apps as $app): ?>
                    <option value="<?php echo $app['id'] ?>"><?php echo $app['name'] ?></option>
                <?php endforeach; ?>
            </select><br>
            <input type="submit" name="check" value="Check">
            <input type="submit" name="submit"value="Search">

        </form>
        <?php if (isset($_POST['submit'])): ?>
            <?php
            $min_fans = $_POST['min_fans']; //TODO
            $max_fans = $_POST['max_fans']; //TODO
            $keyword = $_POST['keyword']; //TODO
            $company = $_POST["id_company"];
            $apps = $_POST["id_apps"];
            if (!empty($company))
                $company = "companies.id=$company AND";
            else
                $company = "";
            if (!empty($apps))
                $apps = "apps.id=$apps AND";
            else
                $apps = "";

            if (empty($max_fans) && !empty($min_fans)) {
                $query = "SELECT * FROM pages 
                  INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
                  WHERE $company
                      $apps
                      (likes >= $min_fans)
                      AND (description LIKE '% $keyword %')
                  LIMIT 0, 10
                  ";
            } else if (!empty($max_fans) && empty($min_fans)) {
                $query = "SELECT * FROM pages 
                  INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
                  WHERE $company
                      $apps
                      (likes <= $max_fans)
                      AND (description LIKE '% $keyword %')
                      
                  LIMIT 0, 10
                  ";
            } else if (empty($max_fans) && empty($min_fans)) {
                $query = "SELECT * FROM pages
             INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
             WHERE $company
                 $apps
             (description LIKE '% $keyword %')
                  LIMIT 0, 10
                  ";
            } else {
                $query = "SELECT * FROM pages  
             INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
                  WHERE $company
                      $apps
                      (likes >= $min_fans)
                      AND (likes <= $max_fans)
                      AND (description LIKE '% $keyword %')
                  LIMIT 0, 10
                  ";
            }
            var_dump($query);
            $pages = getFilms($query);
            ?>  
            <?php if (!empty($pages)): ?>
                <table border ="2">
                    <tr>
                        <th>Picture</th>
                        <th>Likes</th>
                        <th>Company</th>
                        <th> Description </th>

                    </tr>
                    <?php foreach ($pages as $page): ?>
                        <tr>
                            <td><img src='<?php echo $page['picture'] ?>'></td>
                            <td><?php echo $page['likes'] ?></td>
                            <td><?php echo $page['name'] ?></td>
                            <td><?php echo substr($page['description'], 0, 100) ?></td>


                        </tr>
                    <?php endforeach; ?>
                </table> 

            <?php endif; ?>
        <?php endif; ?>
        <script type="text/javascript">
            var txt = Document.getElementById("min_fans").value;
            alert("min_fans: " + txt);
        </script>
        <script>
            $(document).ready(function (){
                $('#check').click(function (){
                    var min_fans = $('#min_fans').val();
                    var flag = checkNumber(min_fans);
                    if (flag){
                        alert('is number');
                    }else{
                        alert('is not number');
                    }
                });
            });
               function checkNumber(val){
                   if ($.isNumeric(val)){
                       return true;
                   }else{
                       return false;
                   }
               } 
            
        </script>
    </body>    

</html>